Main
Giovanni Colitti
Experience
Business Intelligence Analyst
Fieldin
Remote
2020 - Current
- Developed Shiny apps to summarize data, explore data through interactive maps, and create PowerPoint presentations.
- Predicted machine unloading events with 90% accuracy.
- Designed flexible visualizations and tables of customer KPIs.
- Built a framework for estimating customer costs.
- Improved standardization, reproducibility, and audibility of all information by carefully defining metric conversions & formatting.
- Used Docker and ShinyProxy to publish applications and reports.
- Managed database tables using R and SQL.
Jr. Data Scientist
Grimmway
Bakersfield, CA
2018 - 2020
- Trained ML models in R to forecast important business metrics including sales and yield; forecasts improved predictive accuracy by 30-50% over previous methods.
- Implemented linear programming problems in R to optimize planting and harvesting activities.
- Performed complex data cleaning and exploration on large datasets.
- Analyzed field trial data in R using appropriate statistical methods.
- Developed {tidyroll}, an R package for performing cross-validation of time-series data with irregular time slices; and {coagmetr}, an R package used to interface with the CoAgMET weather network API.
- Created Shiny apps to visualize forecasts, implement constrained optimization problems, and generate automated reports.
- Built object detection pipeline to automatically generate carrot stand count estimates.
- Performed sample size calculations and provided spatial sampling recommendations.
- Communicated analytical methods and results to the executive team.
Data Analyst Intern
Small Business Development Center
Camarillo, CA
2015 - 2016
- Analyzed small business metrics, such as revenue per employee, to predict which clients have the highest risk of bankruptcy.
- Used model predictions to efficiently allocate limited consulting resources to assist at-risk businesses.
- Trained executive team in statistical methods.
Research Assistant
California State Univeristy, Channel Islands
Camarillo, CA
2014
- Collected and cleaned data from various online sources using Stata programming.
- Created visualizations in Stata and wrote literature reviews of scientific articles related to Chinese & Indian stock, currency, and debt markets.
Education
National Taiwan University
M.S. in Agricultural Economics (4.0 GPA)
Taipei, Taiwan
2018
California State University, Channel Islands
B.A. in Economics (3.8 GPA)
Camarillo, CA
2016
Selected Research
Do Concealed Firearms Decrease Crime? An Analysis Using Active Concealed Firearm License Data in the United States
Used a unique dataset on county-level concealed firearms permits and applied two-stage least squares estimation to show that concealed firearms do not decrease crime.
N/A
2018
Do HEVs Cause More Cyclist & Pedestrian Injuries?
Used logit model & large UK accident-level dataset to show that quieter electric vehicles significantly increase pedestrian accidents net of other covariates including speed limit and urbanization. Also used Bayesian methods (MCMC) to estimate the posterior distribution and check for non-normality in estimates.
N/A
2018
Effect of Hurricane Morakot on Agricultural Prices in Taiwan
Used a difference-in-differences (DiD) event study model and a large transaction-level dataset to quantify the casual effect of Hurricane Morakot on vegetable prices in Taiwan, adding weight to the literature that claims weather is oftentimes the most important driver of local agricultural prices.
N/A
2018
Academic Honors and Awards
Thesis Competition First Place Prize
Master’s thesis presentation competition first place winner.
N/A
2018
Taiwan Ministry of Education Scholarship
Merit scholarship for post-graduate studies in Taiwan.
N/A
2016
Program Honors in Ecnomomics
Selected by CSUCI Economics Department faculty for outstanding achievement.
N/A
2016
Wang Family Scholarship
Merit scholarship for international study in Taiwan & Mainland China.
N/A
2014
President’s Scholarship
Highest scholastic achievement award in CSU system; only handful awarded annually.
N/A
2012
Disclaimer
Last updated on 2022-01-04.